select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')
Satin Light Blue Dama Dress with a Brush Train and a Sash
Olive Green Knee-length Chiffon Sweet 15 Dama Dress with a Sash
Baby Pink Halter Top Column Floor-length Dama Dress in Satin
Column Strapless Dama Dress in Lilac with Belt and Ruches
Pink Strapless Empire Ankle-length Chiffon Dama Dress with Sash
Spaghetti Straps Apple Green Column Brush Train Dama Dress
Baby Blue Halter Chiffon Dama Dress with Ruches and Ruffles
Spaghetti Straps Black Sash Knee-length 2013 White Dama Dress
Straps V-neck Orange Ruched and Ruffled Knee-length Dama Dress
Spaghetti Straps Royal Blue A-line Mini-length Ruched Dama Dress
A-line Dark Green Strapless Ruche Chiffon Dama Dress Knee-length
Spaghetti Straps Yellow Column Ankle-length Dama Dress With Bow
V-neck Peacock Blue Empire Mini-length Dama Dress with Ruches
Simple Baby Pink Strapless Ruched Floor-length 2013 Dama Dress
Spaghetti Straps Baby Pink Tea-length Dama Dress With Sash
Black Empire Strapless Knee-length Prom Dresses For Dama with Pink Sash
Teal Empire Straps Knee-length Chiffon Ruching Damas Dresses For Quince
A-line Strapless ea-length Lace with Purple Bow Dresses For Damas
White and Pink A-line Scoop Mini-length Formal Dresses For Dama
Damas Dresses Black and White One Shoulder Floor-length
Modern Red One Shoulder Chiffon Ruched Prom Dresses for Dama
Baby Pink Straps Tea-length Chiffon Dama Dresses with Hand made Flower
Princess Off the Shoulder Prom Dress with Appliques in Organza
A-line One Shoulder Prom Dress for Quince with Hand Made Flowers
Taffeta and Tulle Quince Dress in Teal and White with Floor-length
Multi-color Sweetheart Sweet 15th Dress with Ruffles and Appliques
White and Olive Green Ball Gown Quince Dress in Taffeta and Tulle
Ball Gown Dress Quinces with Embroidery in White and Turquoise
Multi-colored Ruffled Sweet 15th Dress with One Shoulder Strap
Beaded Strapless Ball Gown Dress for Quinces with Floor-length